create table "public"."properties" (
    "id" bigint generated by default as identity not null,
    "created_at" timestamp with time zone default now(),
    "user_id" uuid,
    "request_id" uuid,
    "auth_hash" text,
    "key" text,
    "value" text
);


alter table "public"."properties" enable row level security;

CREATE UNIQUE INDEX properties_pkey ON public.properties USING btree (id);

alter table "public"."properties" add constraint "properties_pkey" PRIMARY KEY using index "properties_pkey";

alter table "public"."properties" add constraint "properties_request_id_fkey" FOREIGN KEY (request_id) REFERENCES request(id) not valid;

alter table "public"."properties" validate constraint "properties_request_id_fkey";

alter table "public"."properties" add constraint "properties_user_id_fkey" FOREIGN KEY (user_id) REFERENCES auth.users(id) not valid;

alter table "public"."properties" validate constraint "properties_user_id_fkey";


